USE WarehouseManagement
GO

CREATE PROCEDURE Validate
(
	@Username nvarchar(MAX) = NULL,
	@Password nvarchar(MAX) = NULl
)
AS
BEGIN
	SELECT 1 AS 'IsValid' FROM Employee WHERE [UserName] = @Username AND [Password] = @Password
END

/*
EXEC Validate @Username = 'admin', @Password = 'admin@12345'
*/